drop table if exists jms_dwd.dwd_tab_barscan_cycle_transfer_record_base_dt;
create external table jms_dwd.dwd_tab_barscan_cycle_transfer_record_base_dt
(
  id                  bigint comment'主键ID',
  transfer_code       string comment'调拨单号_ef',
  shipment_no           string comment'任务单号_ef',
  transfer_type       bigint comment'调拨类型:1调拨出库；2调拨入库_ef',
  scan_time           timestamp comment'扫描时间_ef',
  scan_network_code   string comment'扫描网点编码_ef',
  scan_network_name   string comment'扫描网点名称_ef',
  recycle_bags_number bigint comment'循环袋数量（数量=包数*20）_ef',
  recycle_bags_weight bigint comment'重量（重量=包数*8，单位为kg）_ef',
  next_network_code   string comment'下一站网点编码_ef',
  next_network_name   string comment'下一站网点名称_ef',
  scan_by_name        string comment'扫描人员名称_ef',
  scan_by_code        string comment'扫描员编码_ef',
  upload_time         timestamp comment'上传时间_ef',
  package_quantity    bigint comment'包数量_ef'
) comment'循环袋表'
stored as parquet
location "/dw/hive/jms_dwd.db/external/dwd_tab_barscan_cycle_transfer_record_base_dt"
;